forum

home / developersection / forums / how to import csv file data in sql server table?

Ask Question

How to import csv file data in SQL server table?

Anonymous User 4000 24-Mar-2012
Hello Guys,
I'm facing a problem since last night, please help me! Actually I want to import csv file data in sql server database but I didn't. Could you explain it with code?

Please reply as soon as possible. Thanks in advance!!
mssql server mssql server 
Updated on 26-Mar-2012
Anonymous User

Other

I am a content writter !

Message
Can you answer this question?
Answer

1 Answers

Anonymous User

Anonymous User

26-Mar-2012

Hi Tanuj Kumar,
To import data from csv file in SQL Server, you have to use BULK Query Command. Let's take look of Bulk Query Command query.

Query:  

BULK INSERT tbl_Name
               FROM 'csvFileNamewith Path'
                  WITH 
                     (
                        FIELDTERMINATOR = ','
                     )
I hope it might be resolve your problem.

advertising
advertising

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy